<? 
include_once("codelibrary/inc/variables.php");
include_once("session.php");
include_once("codelibrary/inc/functions.php");

$business_id = $_SESSION['business_id'];

if(isset($_REQUEST['business_id']))
{
	$business_id = $_REQUEST['business_id'];
	$staff_id = $_REQUEST['staff_id'];
	$qry = mysql_query("select * from staff where staff_id = '".$staff_id."' and business_id = '".$business_id."'");
	$record = mysql_fetch_array($qry);
}
// --------------------  Code to insert into staff table --------------------------
if(isset($_REQUEST['ab']))
{
	$service_id = $_REQUEST['ab'];
	foreach($service_id as $q)
	{
		$qry = mysql_query("select * from staff_offered where business_id = '".$business_id."' and staff_id = '".$staff_id."' and service_id = '".$q."'");
		if(mysql_num_rows($qry) == 0)
		{
			mysql_query("insert into staff_offered(business_id, staff_id, service_id) values('".$business_id."', '".$staff_id."', '".$q."')");
		}
	}
}

$query = mysql_query("select * from services where business_id = '".$business_id."'");
$rows = mysql_num_rows($query);

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html dir="LTR" lang="en">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Online Appointment</title>

<base >
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<title>Staff Management</title>

</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">


<table cellpadding="0" cellspacing="0" border="0"><tr>
  <td style="background:url(images/top.gif) repeat-x top; ">
<table cellpadding="0" cellspacing="0" border="0" style="width:764px" align="center"> 
	<tr>
		<td>
			<table cellpadding="0" cellspacing="0" border="0" style="height:57">
				<tr>
					<td height="57">
<? html_header(); ?>					</td>
				</tr>
			</table>


		</td>
	</tr>
	<tr>
		<td>





<table border="0" width="105%" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" class="col_left">

<table border="0"cellspacing="0" cellpadding="0" class="box_width_left">
	<tr><td width="100%">
		<table border="0" cellspacing="0" cellpadding="0">
<tr><td>

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="">
  <tr>
    <td>
    <table border="0" width="100%" cellspacing="0" cellpadding="0"  class="" height="91">
  <tr>
    <td align="center" height="91">
    <img border="0" src="images/logo.jpg" width="208" height="86"></td>
  </tr>
</table>
</td>
  </tr>
</table>
</td></tr>


          <tr>
            <td>
<table border="0" width="100%" cellspacing="0" cellpadding="0"  class="box_header_txt" height="48">
  <tr>
    <td style="background-image: url(images/1_bg2-2.gif)" height="1">
      <p style="margin-top: 16"> </td>
  </tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0"   style="border-bottom:12px solid #ffffff;">
  <tr>
    <td>
    <table border="0" width="100%" cellspacing="0" cellpadding="0"  style="margin-bottom:0px;background:#7C7C7C url(images/1_line.gif) no-repeat left bottom;" >
  <tr>
    <td  style="padding:3px 16px 8px 25px;">
      <table width="100%" border="0" cellpadding="5" cellspacing="3">
        <tr>
          <td colspan="2" align="left"><a href="profile.php?business_id=<? echo $business_id;?>&staff_id=<? echo $staff_id;?>" class="topmenulink">Profile Information </a> </td>
        </tr>
        <tr>
          <td colspan="2"><a href="staff_schedule.php?business_id=<? echo $business_id;?>&staff_id=<? echo $staff_id;?>" class="topmenulink">Schedule</a></td>
        </tr>
        <tr>
          <td colspan="2"><a href="service_offered.php?business_id=<? echo $business_id;?>&staff_id=<? echo $staff_id;?>" class="topmenulink">Services Offered </a></td>
        </tr>
        <tr>
          <td colspan="2"><a href="staff_offdays.php?business_id=<? echo $business_id;?>&staff_id=<? echo $staff_id;?>" class="topmenulink">Days Off </a></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
            </td>
          </tr>


          <tr>
            <td class="">&nbsp;
</td>
          </tr>

		</table>
	</td>
	<td><img src="images/spacer.gif" border="0" alt="" width="15" height="1"></td></tr>
</table>

    </td>

    <td width="100%" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0"  class="cont_header_txt">
  <tr>
    <td>
			<table border="0" cellpadding="0" cellspacing="0" bgcolor="#EAEAEA" class="cont_header_txt">
				<tr>
					<td><img src="images/1_q1.gif" border="0" alt="" width="45" height="39"></td>
					<td style="width:100%"><? echo $record['first_name']." ".$record['last_name'];?></td>
					<td><img src="images/1_q2.gif" border="0" alt="" width="10" height="39"></td>
				</tr>
			</table>										 
			</td>
  </tr>
</table>


						
												<form name="form1" method="post" action="">
						<table width="107%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFDBCA" class="table" >
						<? if($rows != 0) {?>
                          <tr>
                            <td width="23%" height="25" align="center" bgcolor="#FFFFFF" class="H1"><!-- new_products //-->Service Offered </td>
                            <td width="26%" height="25" align="center" bgcolor="#FFFFFF" class="H1" >Service Description </td>
                            <td width="28%" height="25" align="center" bgcolor="#FFFFFF" class="H1" >Time to Complete  </td>
                            <td width="23%" height="25" align="center" bgcolor="#FFFFFF" class="H1" >Cost</td>
                          </tr>
						  <? while($data = mysql_fetch_array($query)) {?>
                          <tr>
                            <td height="25" align="center" bgcolor="#FFFFFF" class="simpletxt">&nbsp;
                              <label>
                              <input type="checkbox" name="ab[]" value="<? echo $data['service_id'];?>">
                            </label></td>
                            <td height="25" bgcolor="#FFFFFF" class="simpletxt" >&nbsp;<? echo $data['title'];?></td>
                            <td height="25" bgcolor="#FFFFFF" class="simpletxt" >&nbsp;&nbsp;<? echo $data['duration'];?>                           </td>
                            <td height="25" align="center" bgcolor="#FFFFFF" class="simpletxt" ><? echo $data['cost'];?></td>
                          </tr>
						  <? }?>
						  <tr>
	                        <td height="25" colspan="4" align="center" bgcolor="#FFFFFF" class="errTxt"><label> <br>
	                        <input name="Submit" type="submit" class="button" value="Update">
	                        </label></td>
                          </tr>

						  <? }else {?>
	                      <tr>
                            <td height="25" colspan="4" align="center" bgcolor="#FFFFFF" class="errTxt"><p><br>
                                <br>
                              No Services are Available....<br>
                            </p>
                            <p>&nbsp;</p></td>
                          </tr>
						  <? }?>
                        </table>
												</form>
						
						<table cellpadding="0" cellspacing="0" border="0">
							<tr>
								<td><img src="images/1_q4.gif" border="0" alt="" width="10" height="10"></td>
								<td style="width:100%; background-image:url(images/1_li1.gif)"></td>
								<td><img src="images/1_q3.gif" border="0" alt="" width="10" height="10"></td>
							</tr>
						</table>
						


		
		
		</td>

    <td class="col_right">

<table border="0"cellspacing="0" cellpadding="0" class="box_width_right">
	<tr><td></td>
		<td width="100%">
			<table border="0" cellspacing="0" cellpadding="0">
				<tr><td></td></tr>
			</table>
		</td>
	</tr>
</table>


    </td>
  </tr>
</table>



		</td>
	</tr>
	<tr>
		<td>
			<table cellpadding="0" cellspacing="0" border="0" style="height:98px; background-image:url(images/bot.gif)">
				<tr>
					<td>
						<table cellpadding="0" cellspacing="0" border="0" class="footer">
							<tr>									
								<td height="77"><img src="images/spacer.gif" border="0" alt="" width="25" height="1"></td>				
								<td style="width:207px"><br style="line-height:49px"><img src="images/p1.gif" border="0" alt="" width="145" height="24"><br></td>
							  <td style="width:532px">&nbsp;</td>
							</tr>
						</table>
					</td>
				</tr>
			</table>
		</td>
	</tr>
</table></td></tr></table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center"></td>
  </tr>
</table>
</body>

</html>